Pandas Profiling Report

Dataset statistics

Number of variables	30
Number of observations	1100000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	244.4 MiB
Average record size in memory	233.0 B

Variable types

Numeric	17
Categorical	12
Boolean	1

Alerts

`fuel_tank_volume` has a high cardinality: 139 distinct values	High cardinality
`listed_date` has a high cardinality: 1212 distinct values	High cardinality
`model_name` has a high cardinality: 656 distinct values	High cardinality
`city_fuel_economy` is highly correlated with `engine_displacement` and 8 other fields	High correlation
`daysonmarket` is highly correlated with `listing_id`	High correlation
`engine_displacement` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`height` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`highway_fuel_economy` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`horsepower` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`is_new` is highly correlated with `mileage` and 1 other fields	High correlation
`length` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`listing_id` is highly correlated with `daysonmarket`	High correlation
`mileage` is highly correlated with `is_new` and 1 other fields	High correlation
`price` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`wheelbase` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`width` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`year` is highly correlated with `is_new` and 2 other fields	High correlation
`Torque_lb_ft` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`back_legroom` is highly correlated with `height`	High correlation
`city_fuel_economy` is highly correlated with `engine_displacement` and 7 other fields	High correlation
`daysonmarket` is highly correlated with `listing_id`	High correlation
`engine_displacement` is highly correlated with `city_fuel_economy` and 6 other fields	High correlation
`height` is highly correlated with `back_legroom` and 8 other fields	High correlation
`highway_fuel_economy` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`horsepower` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`is_new` is highly correlated with `mileage` and 1 other fields	High correlation
`length` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`listing_id` is highly correlated with `daysonmarket`	High correlation
`mileage` is highly correlated with `is_new` and 1 other fields	High correlation
`price` is highly correlated with `horsepower` and 1 other fields	High correlation
`wheelbase` is highly correlated with `city_fuel_economy` and 7 other fields	High correlation
`width` is highly correlated with `city_fuel_economy` and 6 other fields	High correlation
`year` is highly correlated with `is_new` and 1 other fields	High correlation
`Torque_lb_ft` is highly correlated with `city_fuel_economy` and 8 other fields	High correlation
`city_fuel_economy` is highly correlated with `engine_displacement` and 6 other fields	High correlation
`daysonmarket` is highly correlated with `listing_id`	High correlation
`engine_displacement` is highly correlated with `city_fuel_economy` and 5 other fields	High correlation
`height` is highly correlated with `city_fuel_economy` and 1 other fields	High correlation
`highway_fuel_economy` is highly correlated with `city_fuel_economy` and 4 other fields	High correlation
`horsepower` is highly correlated with `city_fuel_economy` and 6 other fields	High correlation
`is_new` is highly correlated with `mileage` and 1 other fields	High correlation
`length` is highly correlated with `city_fuel_economy` and 4 other fields	High correlation
`listing_id` is highly correlated with `daysonmarket`	High correlation
`mileage` is highly correlated with `is_new` and 1 other fields	High correlation
`wheelbase` is highly correlated with `city_fuel_economy` and 5 other fields	High correlation
`width` is highly correlated with `horsepower` and 2 other fields	High correlation
`year` is highly correlated with `is_new` and 1 other fields	High correlation
`Torque_lb_ft` is highly correlated with `city_fuel_economy` and 6 other fields	High correlation
`maximum_seating` is highly correlated with `body_type`	High correlation
`fuel_type` is highly correlated with `engine_cylinders`	High correlation
`engine_cylinders` is highly correlated with `fuel_type`	High correlation
`transmission_display` is highly correlated with `transmission`	High correlation
`body_type` is highly correlated with `maximum_seating`	High correlation
`transmission` is highly correlated with `transmission_display`	High correlation
`back_legroom` is highly correlated with `body_type` and 8 other fields	High correlation
`body_type` is highly correlated with `back_legroom` and 12 other fields	High correlation
`city_fuel_economy` is highly correlated with `engine_cylinders` and 11 other fields	High correlation
`daysonmarket` is highly correlated with `listing_id`	High correlation
`engine_cylinders` is highly correlated with `body_type` and 16 other fields	High correlation
`engine_displacement` is highly correlated with `body_type` and 14 other fields	High correlation
`franchise_make` is highly correlated with `back_legroom` and 17 other fields	High correlation
`front_legroom` is highly correlated with `franchise_make`	High correlation
`fuel_type` is highly correlated with `engine_cylinders`	High correlation
`height` is highly correlated with `back_legroom` and 13 other fields	High correlation
`highway_fuel_economy` is highly correlated with `body_type` and 12 other fields	High correlation
`horsepower` is highly correlated with `back_legroom` and 14 other fields	High correlation
`is_new` is highly correlated with `year`	High correlation
`length` is highly correlated with `back_legroom` and 14 other fields	High correlation
`listing_id` is highly correlated with `daysonmarket`	High correlation
`maximum_seating` is highly correlated with `back_legroom` and 11 other fields	High correlation
`transmission` is highly correlated with `engine_cylinders` and 2 other fields	High correlation
`transmission_display` is highly correlated with `city_fuel_economy` and 10 other fields	High correlation
`wheel_system` is highly correlated with `body_type` and 13 other fields	High correlation
`wheelbase` is highly correlated with `back_legroom` and 14 other fields	High correlation
`width` is highly correlated with `back_legroom` and 15 other fields	High correlation
`year` is highly correlated with `is_new`	High correlation
`Torque_lb_ft` is highly correlated with `back_legroom` and 15 other fields	High correlation
`Torque_RPM` is highly correlated with `engine_cylinders` and 5 other fields	High correlation
`listing_id` has unique values	Unique
`mileage` has 97317 (8.8%) zeros	Zeros

Reproduction

Analysis started	2022-09-04 20:06:59.888502
Analysis finished	2022-09-04 20:12:11.664750
Duration	5 minutes and 11.78 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

back_legroom
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	185
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.16277464

Minimum	0
Maximum	59.8
Zeros	183
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	0
5-th percentile	33.4
Q1	36.1
median	38.3
Q3	39.9
95-th percentile	43.6
Maximum	59.8
Range	59.8
Interquartile range (IQR)	3.8

Descriptive statistics

Standard deviation	3.009839003
Coefficient of variation (CV)	0.07886845315
Kurtosis	4.943097315
Mean	38.16277464
Median Absolute Deviation (MAD)	1.8
Skewness	-0.4878789797
Sum	41979052.1
Variance	9.059130826
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.3	47851	4.4%
43.6	47609	4.3%
35.7	41227	3.7%
40.4	32427	2.9%
38.6	31567	2.9%
37.4	31181	2.8%
37.9	29463	2.7%
35.2	28621	2.6%
38.4	26776	2.4%
38.1	25858	2.4%
Other values (175)	757420	68.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	183	< 0.1%
3.5	2	< 0.1%
17.1	3	< 0.1%
20.2	3	< 0.1%
23.1	26	< 0.1%
23.7	1	< 0.1%
23.8	1	< 0.1%
24.6	415	< 0.1%
24.8	145	< 0.1%
24.9	5	< 0.1%

Value	Count	Frequency (%)
59.8	2	< 0.1%
49	1	< 0.1%
47.5	66	< 0.1%
47.4	16	< 0.1%
46.8	43	< 0.1%
45.2	22022	2.0%
44.5	108	< 0.1%
44.4	687	0.1%
44.3	2333	0.2%
44.2	7	< 0.1%

body_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

SUV / Crossover	594453
Sedan	253830
Pickup Truck	158090
Minivan	36023
Coupe	21119
Other values (4)	36485

Length

Max length	15
Median length	15
Mean length	11.56969818
Min length	3

Characters and Unicode

Total characters	12726668
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sedan
2nd row	Coupe
3rd row	SUV / Crossover
4th row	SUV / Crossover
5th row	SUV / Crossover

Common Values

Value	Count	Frequency (%)
SUV / Crossover	594453	54.0%
Sedan	253830	23.1%
Pickup Truck	158090	14.4%
Minivan	36023	3.3%
Coupe	21119	1.9%
Hatchback	18856	1.7%
Wagon	11888	1.1%
Convertible	4940	0.4%
Van	801	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
suv	594453	24.3%
	594453	24.3%
crossover	594453	24.3%
sedan	253830	10.4%
pickup	158090	6.5%
truck	158090	6.5%
minivan	36023	1.5%
coupe	21119	0.9%
hatchback	18856	0.8%
wagon	11888	0.5%
Other values (2)	5741	0.2%

Most occurring characters

Value	Count	Frequency (%)
r	1351936	10.6%
	1346996	10.6%
o	1226853	9.6%
s	1188906	9.3%
e	879282	6.9%
S	848283	6.7%
v	635416	5.0%
C	620512	4.9%
V	595254	4.7%
/	594453	4.7%
Other values (19)	3438777	27.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7743770	60.8%
Uppercase Letter	3041449	23.9%
Space Separator	1346996	10.6%
Other Punctuation	594453	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1351936	17.5%
o	1226853	15.8%
s	1188906	15.4%
e	879282	11.4%
v	635416	8.2%
c	353892	4.6%
n	343505	4.4%
a	340254	4.4%
u	337299	4.4%
k	335036	4.3%
Other values (8)	751391	9.7%

Uppercase Letter

Value	Count	Frequency (%)
S	848283	27.9%
C	620512	20.4%
V	595254	19.6%
U	594453	19.5%
T	158090	5.2%
P	158090	5.2%
M	36023	1.2%
H	18856	0.6%
W	11888	0.4%

Space Separator

Value	Count	Frequency (%)
	1346996	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	594453	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10785219	84.7%
Common	1941449	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1351936	12.5%
o	1226853	11.4%
s	1188906	11.0%
e	879282	8.2%
S	848283	7.9%
v	635416	5.9%
C	620512	5.8%
V	595254	5.5%
U	594453	5.5%
c	353892	3.3%
Other values (17)	2490432	23.1%

Common

Value	Count	Frequency (%)
	1346996	69.4%
/	594453	30.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12726668	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1351936	10.6%
	1346996	10.6%
o	1226853	9.6%
s	1188906	9.3%
e	879282	6.9%
S	848283	6.7%
v	635416	5.0%
C	620512	4.9%
V	595254	4.7%
/	594453	4.7%
Other values (19)	3438777	27.0%

city_fuel_economy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.46764727

Minimum	9
Maximum	74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	9
5-th percentile	15
Q1	18
median	21
Q3	25
95-th percentile	30
Maximum	74
Range	65
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.669318466
Coefficient of variation (CV)	0.2175048997
Kurtosis	0.5862573737
Mean	21.46764727
Median Absolute Deviation (MAD)	4
Skewness	0.4908857145
Sum	23614412
Variance	21.80253494
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
19	98472	9.0%
18	95954	8.7%
22	86645	7.9%
21	78977	7.2%
16	78296	7.1%
17	74296	6.8%
26	72047	6.5%
20	71110	6.5%
15	67130	6.1%
25	60729	5.5%
Other values (39)	316344	28.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9	30	< 0.1%
10	37	< 0.1%
11	269	< 0.1%
12	4014	0.4%
13	8587	0.8%
14	15674	1.4%
15	67130	6.1%
16	78296	7.1%
17	74296	6.8%
18	95954	8.7%

Value	Count	Frequency (%)
74	4	< 0.1%
70	19	< 0.1%
67	50	< 0.1%
66	28	< 0.1%
65	1	< 0.1%
63	6	< 0.1%
62	7	< 0.1%
60	1	< 0.1%
59	12	< 0.1%
58	29	< 0.1%

daysonmarket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1225
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	79.98140636

Minimum	0
Maximum	2567
Zeros	10983
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	18
median	40
Q3	89
95-th percentile	293
Maximum	2567
Range	2567
Interquartile range (IQR)	71

Descriptive statistics

Standard deviation	103.930005
Coefficient of variation (CV)	1.299427076
Kurtosis	21.74913493
Mean	79.98140636
Median Absolute Deviation (MAD)	27
Skewness	3.118205729
Sum	87979547
Variance	10801.44594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	23286	2.1%
13	20785	1.9%
14	20626	1.9%
15	20340	1.8%
12	20246	1.8%
7	19631	1.8%
20	19567	1.8%
6	18869	1.7%
21	18320	1.7%
19	17753	1.6%
Other values (1215)	900577	81.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10983	1.0%
1	12234	1.1%
2	8402	0.8%
3	6220	0.6%
4	10979	1.0%
5	16832	1.5%
6	18869	1.7%
7	19631	1.8%
8	23286	2.1%
9	16440	1.5%

Value	Count	Frequency (%)
2567	1	< 0.1%
2527	1	< 0.1%
2499	1	< 0.1%
2464	1	< 0.1%
2337	1	< 0.1%
2296	1	< 0.1%
2194	1	< 0.1%
2182	1	< 0.1%
2150	1	< 0.1%
2073	1	< 0.1%

engine_cylinders
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

I4	567169
V6	320651
V8	103424
H4	27590
V6 Flex Fuel Vehicle	25969
Other values (21)	55197

Length

Max length	25
Median length	2
Mean length	2.833386364
Min length	2

Characters and Unicode

Total characters	3116725
Distinct characters	37
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	I4
2nd row	V6
3rd row	V6
4th row	V6
5th row	V6

Common Values

Value	Count	Frequency (%)
I4	567169	51.6%
V6	320651	29.2%
V8	103424	9.4%
H4	27590	2.5%
V6 Flex Fuel Vehicle	25969	2.4%
V8 Flex Fuel Vehicle	18931	1.7%
I3	16448	1.5%
I6	7473	0.7%
I6 Diesel	2930	0.3%
I4 Flex Fuel Vehicle	2474	0.2%
Other values (16)	6941	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
i4	571729	45.7%
v6	349694	28.0%
v8	122355	9.8%
flex	47387	3.8%
fuel	47387	3.8%
vehicle	47387	3.8%
h4	27628	2.2%
i3	16448	1.3%
i6	10407	0.8%
diesel	5540	0.4%
Other values (11)	4337	0.3%

Most occurring characters

Value	Count	Frequency (%)
I	599361	19.2%
4	599357	19.2%
V	519606	16.7%
6	360743	11.6%
e	204948	6.6%
	150299	4.8%
l	149861	4.8%
8	122355	3.9%
F	94774	3.0%
i	57673	1.9%
Other values (27)	257748	8.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1250299	40.1%
Decimal Number	1100316	35.3%
Lowercase Letter	615811	19.8%
Space Separator	150299	4.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	204948	33.3%
l	149861	24.3%
i	57673	9.4%
u	47390	7.7%
c	47387	7.7%
x	47387	7.7%
h	47387	7.7%
s	7706	1.3%
d	2592	0.4%
o	2160	0.4%
Other values (7)	1320	0.2%

Uppercase Letter

Value	Count	Frequency (%)
I	599361	47.9%
V	519606	41.6%
F	94774	7.6%
H	28702	2.3%
D	5540	0.4%
B	2157	0.2%
W	146	< 0.1%
R	4	< 0.1%
C	3	< 0.1%
N	3	< 0.1%

Decimal Number

Value	Count	Frequency (%)
4	599357	54.5%
6	360743	32.8%
8	122355	11.1%
3	16448	1.5%
5	777	0.1%
1	316	< 0.1%
2	316	< 0.1%
0	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	150299	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1866110	59.9%
Common	1250615	40.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	599361	32.1%
V	519606	27.8%
e	204948	11.0%
l	149861	8.0%
F	94774	5.1%
i	57673	3.1%
u	47390	2.5%
c	47387	2.5%
x	47387	2.5%
h	47387	2.5%
Other values (18)	50336	2.7%

Common

Value	Count	Frequency (%)
4	599357	47.9%
6	360743	28.8%
	150299	12.0%
8	122355	9.8%
3	16448	1.3%
5	777	0.1%
1	316	< 0.1%
2	316	< 0.1%
0	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3116725	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	599361	19.2%
4	599357	19.2%
V	519606	16.7%
6	360743	11.6%
e	204948	6.6%
	150299	4.8%
l	149861	4.8%
8	122355	3.9%
F	94774	3.0%
i	57673	1.9%
Other values (27)	257748	8.3%

engine_displacement
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	56
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2890.219091

Minimum	1000
Maximum	8100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1000
5-th percentile	1400
Q1	2000
median	2500
Q3	3500
95-th percentile	5700
Maximum	8100
Range	7100
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	1210.581976
Coefficient of variation (CV)	0.4188547435
Kurtosis	0.4886084598
Mean	2890.219091
Median Absolute Deviation (MAD)	1000
Skewness	0.9929029442
Sum	3179241000
Variance	1465508.721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	222852	20.3%
3500	154296	14.0%
3600	136966	12.5%
2500	119564	10.9%
2400	85571	7.8%
1500	66315	6.0%
1400	41781	3.8%
5700	37111	3.4%
3000	33245	3.0%
5300	26198	2.4%
Other values (46)	176101	16.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	4364	0.4%
1200	4459	0.4%
1300	15116	1.4%
1400	41781	3.8%
1500	66315	6.0%
1600	23911	2.2%
1700	34	< 0.1%
1800	23036	2.1%
1900	15	< 0.1%
2000	222852	20.3%

Value	Count	Frequency (%)
8100	1	< 0.1%
6800	19	< 0.1%
6700	12	< 0.1%
6600	105	< 0.1%
6400	2349	0.2%
6300	22	< 0.1%
6200	23463	2.1%
6100	59	< 0.1%
6000	439	< 0.1%
5900	14	< 0.1%

franchise_make
Categorical

HIGH CORRELATION

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Chevrolet	161324
Ford	153403
Jeep	99068
Honda	94234
Nissan	82237
Other values (39)	509734

Length

Max length	13
Median length	11
Mean length	5.858822727
Min length	3

Characters and Unicode

Total characters	6444705
Distinct characters	45
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Chevrolet
2nd row	Jeep
3rd row	Chevrolet
4th row	Chevrolet
5th row	Chevrolet

Common Values

Value	Count	Frequency (%)
Chevrolet	161324	14.7%
Ford	153403	13.9%
Jeep	99068	9.0%
Honda	94234	8.6%
Nissan	82237	7.5%
Toyota	57253	5.2%
Hyundai	48561	4.4%
Kia	41656	3.8%
Buick	35958	3.3%
Dodge	29933	2.7%
Other values (34)	296373	26.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chevrolet	161324	14.6%
ford	153403	13.9%
jeep	99068	8.9%
honda	94234	8.5%
nissan	82237	7.4%
toyota	57253	5.2%
hyundai	48561	4.4%
kia	41656	3.8%
buick	35958	3.2%
dodge	29933	2.7%
Other values (37)	303820	27.4%

Most occurring characters

Value	Count	Frequency (%)
e	684249	10.6%
o	626561	9.7%
a	491996	7.6%
r	412297	6.4%
d	404855	6.3%
n	305450	4.7%
i	285099	4.4%
l	268411	4.2%
s	253503	3.9%
t	229119	3.6%
Other values (35)	2483165	38.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5073426	78.7%
Uppercase Letter	1345301	20.9%
Dash Punctuation	18531	0.3%
Space Separator	7447	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	684249	13.5%
o	626561	12.3%
a	491996	9.7%
r	412297	8.1%
d	404855	8.0%
n	305450	6.0%
i	285099	5.6%
l	268411	5.3%
s	253503	5.0%
t	229119	4.5%
Other values (14)	1111886	21.9%

Uppercase Letter

Value	Count	Frequency (%)
C	220054	16.4%
F	164500	12.2%
H	142795	10.6%
M	122782	9.1%
N	103588	7.7%
J	101471	7.5%
B	72306	5.4%
T	68349	5.1%
A	54181	4.0%
I	44180	3.3%
Other values (9)	251095	18.7%

Dash Punctuation

Value	Count	Frequency (%)
-	18531	100.0%

Space Separator

Value	Count	Frequency (%)
	7447	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6418727	99.6%
Common	25978	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	684249	10.7%
o	626561	9.8%
a	491996	7.7%
r	412297	6.4%
d	404855	6.3%
n	305450	4.8%
i	285099	4.4%
l	268411	4.2%
s	253503	3.9%
t	229119	3.6%
Other values (33)	2457187	38.3%

Common

Value	Count	Frequency (%)
-	18531	71.3%
	7447	28.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6444705	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	684249	10.6%
o	626561	9.7%
a	491996	7.6%
r	412297	6.4%
d	404855	6.3%
n	305450	4.7%
i	285099	4.4%
l	268411	4.2%
s	253503	3.9%
t	229119	3.6%
Other values (35)	2483165	38.5%

front_legroom
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	78
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.17207409

Minimum	0
Maximum	52.5
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	0
5-th percentile	40.3
Q1	41
median	41.8
Q3	43
95-th percentile	45
Maximum	52.5
Range	52.5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.451929618
Coefficient of variation (CV)	0.03442869835
Kurtosis	0.622369386
Mean	42.17207409
Median Absolute Deviation (MAD)	0.9
Skewness	0.6302724953
Sum	46389281.5
Variance	2.108099615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.9	90320	8.2%
43.9	66621	6.1%
41.2	63529	5.8%
41	58899	5.4%
41.3	47265	4.3%
42.3	46994	4.3%
40.8	45211	4.1%
41.1	43291	3.9%
44.5	37594	3.4%
40.3	35994	3.3%
Other values (68)	564282	51.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
35.8	100	< 0.1%
36.6	1001	0.1%
37.7	304	< 0.1%
37.8	1	< 0.1%
38	8	< 0.1%
38.7	59	< 0.1%
38.9	42	< 0.1%
39	483	< 0.1%
39.1	1410	0.1%

Value	Count	Frequency (%)
52.5	129	< 0.1%
46.9	91	< 0.1%
46.4	546	< 0.1%
46.3	148	< 0.1%
46.1	4151	0.4%
45.9	25	< 0.1%
45.8	3509	0.3%
45.7	1819	0.2%
45.5	11020	1.0%
45.4	351	< 0.1%

fuel_tank_volume
Categorical

HIGH CARDINALITY

Distinct	139
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

26 gal	96441
14 gal	65603
18.5 gal	63475
13.2 gal	56416
15.9 gal	45064
Other values (134)	773001

Length

Max length	8
Median length	8
Mean length	7.343633636
Min length	5

Characters and Unicode

Total characters	8077997
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	15.8 gal
2nd row	17.4 gal
3rd row	19.4 gal
4th row	22 gal
5th row	24.6 gal

Common Values

Value	Count	Frequency (%)
26 gal	96441	8.8%
14 gal	65603	6.0%
18.5 gal	63475	5.8%
13.2 gal	56416	5.1%
15.9 gal	45064	4.1%
14.5 gal	39962	3.6%
19 gal	38990	3.5%
19.5 gal	37188	3.4%
24 gal	30311	2.8%
24.6 gal	29827	2.7%
Other values (129)	596723	54.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gal	1100000	50.0%
26	96441	4.4%
14	65603	3.0%
18.5	63475	2.9%
13.2	56416	2.6%
15.9	45064	2.0%
14.5	39962	1.8%
19	38990	1.8%
19.5	37188	1.7%
24	30311	1.4%
Other values (130)	626550	28.5%

Most occurring characters

Value	Count	Frequency (%)
	1100000	13.6%
g	1100000	13.6%
a	1100000	13.6%
l	1100000	13.6%
1	865792	10.7%
.	740083	9.2%
2	485851	6.0%
5	318544	3.9%
4	295196	3.7%
6	279146	3.5%
Other values (5)	693385	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3300000	40.9%
Decimal Number	2937914	36.4%
Space Separator	1100000	13.6%
Other Punctuation	740083	9.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	865792	29.5%
2	485851	16.5%
5	318544	10.8%
4	295196	10.0%
6	279146	9.5%
8	209630	7.1%
9	184541	6.3%
3	157882	5.4%
7	95488	3.3%
0	45844	1.6%

Lowercase Letter

Value	Count	Frequency (%)
g	1100000	33.3%
a	1100000	33.3%
l	1100000	33.3%

Space Separator

Value	Count	Frequency (%)
	1100000	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	740083	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4777997	59.1%
Latin	3300000	40.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
	1100000	23.0%
1	865792	18.1%
.	740083	15.5%
2	485851	10.2%
5	318544	6.7%
4	295196	6.2%
6	279146	5.8%
8	209630	4.4%
9	184541	3.9%
3	157882	3.3%
Other values (2)	141332	3.0%

Latin

Value	Count	Frequency (%)
g	1100000	33.3%
a	1100000	33.3%
l	1100000	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8077997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1100000	13.6%
g	1100000	13.6%
a	1100000	13.6%
l	1100000	13.6%
1	865792	10.7%
.	740083	9.2%
2	485851	6.0%
5	318544	3.9%
4	295196	3.7%
6	279146	3.5%
Other values (5)	693385	8.6%

fuel_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Gasoline	1044481
Flex Fuel Vehicle	47387
Diesel	5540
Biodiesel	2157
Hybrid	432

Length

Max length	22
Median length	8
Mean length	8.378852727
Min length	6

Characters and Unicode

Total characters	9216738
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gasoline
2nd row	Gasoline
3rd row	Gasoline
4th row	Gasoline
5th row	Gasoline

Common Values

Value	Count	Frequency (%)
Gasoline	1044481	95.0%
Flex Fuel Vehicle	47387	4.3%
Diesel	5540	0.5%
Biodiesel	2157	0.2%
Hybrid	432	< 0.1%
Compressed Natural Gas	3	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
gasoline	1044481	87.4%
flex	47387	4.0%
fuel	47387	4.0%
vehicle	47387	4.0%
diesel	5540	0.5%
biodiesel	2157	0.2%
hybrid	432	< 0.1%
compressed	3	< 0.1%
natural	3	< 0.1%
gas	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	1249429	13.6%
l	1194342	13.0%
i	1102154	12.0%
s	1052187	11.4%
o	1046641	11.4%
a	1044490	11.3%
G	1044484	11.3%
n	1044481	11.3%
	94780	1.0%
F	94774	1.0%
Other values (17)	248976	2.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7927178	86.0%
Uppercase Letter	1194780	13.0%
Space Separator	94780	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1249429	15.8%
l	1194342	15.1%
i	1102154	13.9%
s	1052187	13.3%
o	1046641	13.2%
a	1044490	13.2%
n	1044481	13.2%
u	47390	0.6%
c	47387	0.6%
h	47387	0.6%
Other values (8)	51290	0.6%

Uppercase Letter

Value	Count	Frequency (%)
G	1044484	87.4%
F	94774	7.9%
V	47387	4.0%
D	5540	0.5%
B	2157	0.2%
H	432	< 0.1%
C	3	< 0.1%
N	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	94780	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9121958	99.0%
Common	94780	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1249429	13.7%
l	1194342	13.1%
i	1102154	12.1%
s	1052187	11.5%
o	1046641	11.5%
a	1044490	11.5%
G	1044484	11.5%
n	1044481	11.5%
F	94774	1.0%
u	47390	0.5%
Other values (16)	201586	2.2%

Common

Value	Count	Frequency (%)
	94780	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9216738	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1249429	13.6%
l	1194342	13.0%
i	1102154	12.0%
s	1052187	11.4%
o	1046641	11.4%
a	1044490	11.3%
G	1044484	11.3%
n	1044481	11.3%
	94780	1.0%
F	94774	1.0%
Other values (17)	248976	2.7%

height
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	295
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	65.93010982

Minimum	49
Maximum	108.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	49
5-th percentile	56.5
Q1	58.9
median	66.2
Q3	69.9
95-th percentile	77.2
Maximum	108.6
Range	59.6
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.575773861
Coefficient of variation (CV)	0.09973855465
Kurtosis	-0.7648451871
Mean	65.93010982
Median Absolute Deviation (MAD)	4.4
Skewness	0.08986854105
Sum	72523120.8
Variance	43.24080187
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66.3	38857	3.5%
77.2	36280	3.3%
66.1	33361	3.0%
66.5	31425	2.9%
69.9	26218	2.4%
57.1	24815	2.3%
64.8	24371	2.2%
56.5	22806	2.1%
58.1	22299	2.0%
69.3	21716	2.0%
Other values (285)	817852	74.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
49	1	< 0.1%
49.1	1	< 0.1%
49.7	1	< 0.1%
50	5	< 0.1%
50.2	1	< 0.1%
50.4	1	< 0.1%
50.6	59	< 0.1%
50.8	1	< 0.1%
51	2	< 0.1%
51.2	7	< 0.1%

Value	Count	Frequency (%)
108.6	15	< 0.1%
107.7	16	< 0.1%
99.2	149	< 0.1%
99.1	2	< 0.1%
98.7	18	< 0.1%
88	11	< 0.1%
84.6	17	< 0.1%
84.5	2	< 0.1%
84.1	17	< 0.1%
83.9	4	< 0.1%

highway_fuel_economy
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.57625182

Minimum	11
Maximum	75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	11
5-th percentile	21
Q1	25
median	28
Q3	32
95-th percentile	39
Maximum	75
Range	64
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.403067935
Coefficient of variation (CV)	0.1890754592
Kurtosis	-0.1370074985
Mean	28.57625182
Median Absolute Deviation (MAD)	4
Skewness	0.3622593934
Sum	31433877
Variance	29.19314311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25	83402	7.6%
22	78261	7.1%
30	77862	7.1%
28	76272	6.9%
29	73550	6.7%
27	71695	6.5%
26	68184	6.2%
31	67226	6.1%
32	57626	5.2%
21	54709	5.0%
Other values (40)	391213	35.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	10	< 0.1%
12	14	< 0.1%
13	38	< 0.1%
14	87	< 0.1%
15	157	< 0.1%
16	435	< 0.1%
17	3751	0.3%
18	8076	0.7%
19	9729	0.9%
20	16803	1.5%

Value	Count	Frequency (%)
75	11	< 0.1%
74	4	< 0.1%
70	50	< 0.1%
68	44	< 0.1%
64	7	< 0.1%
61	6	< 0.1%
58	1	< 0.1%
57	69	< 0.1%
55	2	< 0.1%
53	21	< 0.1%

horsepower
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	342
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	247.7586518

Minimum	74
Maximum	808
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	74
5-th percentile	138
Q1	175
median	248
Q3	300
95-th percentile	395
Maximum	808
Range	734
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	86.48017249
Coefficient of variation (CV)	0.3490500609
Kurtosis	0.09316822693
Mean	247.7586518
Median Absolute Deviation (MAD)	66
Skewness	0.5975287334
Sum	272534517
Variance	7478.820235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
375	46772	4.3%
170	46707	4.2%
395	40503	3.7%
310	36740	3.3%
295	35131	3.2%
138	33068	3.0%
147	31199	2.8%
355	25104	2.3%
280	25014	2.3%
180	24816	2.3%
Other values (332)	754946	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
74	49	< 0.1%
78	1939	0.2%
84	179	< 0.1%
90	1	< 0.1%
93	4	< 0.1%
96	1	< 0.1%
100	45	< 0.1%
101	167	< 0.1%
103	12	< 0.1%
104	4	< 0.1%

Value	Count	Frequency (%)
808	13	< 0.1%
797	125	< 0.1%
760	37	< 0.1%
717	127	< 0.1%
707	396	< 0.1%
700	4	< 0.1%
662	15	< 0.1%
650	135	< 0.1%
640	16	< 0.1%
633	2	< 0.1%

is_new
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

True	572196
False	527804

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	572196	52.0%
False	527804	48.0%

length
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	597
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192.8080766

Minimum	139.6
Maximum	266.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	139.6
5-th percentile	167.6
Q1	182
median	189.8
Q3	200.6
95-th percentile	231.9
Maximum	266.1
Range	126.5
Interquartile range (IQR)	18.6

Descriptive statistics

Standard deviation	18.65402679
Coefficient of variation (CV)	0.09674919805
Kurtosis	0.1563793121
Mean	192.8080766
Median Absolute Deviation (MAD)	8.7
Skewness	0.8093609631
Sum	212088884.3
Variance	347.9727156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
231.9	51431	4.7%
184.5	28921	2.6%
231.7	27359	2.5%
167.6	23986	2.2%
189.8	21457	2.0%
232.9	20903	1.9%
182.1	20567	1.9%
204.3	20539	1.9%
183.1	20507	1.9%
182	19447	1.8%
Other values (587)	844883	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
139.6	173	< 0.1%
142.8	2	< 0.1%
143.1	2	< 0.1%
143.9	9	< 0.1%
144.4	65	< 0.1%
144.7	179	< 0.1%
145.6	65	< 0.1%
146.2	56	< 0.1%
148.8	49	< 0.1%
149.4	1059	0.1%

Value	Count	Frequency (%)
266.1	2	< 0.1%
263.9	16	< 0.1%
250.5	21	< 0.1%
250.4	6	< 0.1%
250.3	3	< 0.1%
249.2	10	< 0.1%
249	4	< 0.1%
247.9	7	< 0.1%
247.8	56	< 0.1%
247.6	2	< 0.1%

listed_date
Categorical

HIGH CARDINALITY

Distinct	1212
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

2020-09-02	24503
2020-08-26	21314
2020-09-03	21300
2020-08-28	21160
2020-08-29	20748
Other values (1207)	990975

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	11000000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	192 ?
Unique (%)	< 0.1%

Sample

1st row	2020-07-16
2nd row	2020-08-04
3rd row	2020-08-13
4th row	2020-08-13
5th row	2020-08-16

Common Values

Value	Count	Frequency (%)
2020-09-02	24503	2.2%
2020-08-26	21314	1.9%
2020-09-03	21300	1.9%
2020-08-28	21160	1.9%
2020-08-29	20748	1.9%
2020-08-27	20581	1.9%
2020-08-21	20020	1.8%
2020-08-22	18923	1.7%
2020-09-04	18218	1.7%
2020-09-05	18215	1.7%
Other values (1202)	895018	81.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-09-02	24503	2.2%
2020-08-26	21314	1.9%
2020-09-03	21300	1.9%
2020-08-28	21160	1.9%
2020-08-29	20748	1.9%
2020-08-27	20581	1.9%
2020-08-21	20020	1.8%
2020-08-22	18923	1.7%
2020-09-04	18218	1.7%
2020-09-05	18215	1.7%
Other values (1202)	895018	81.4%

Most occurring characters

Value	Count	Frequency (%)
0	3636027	33.1%
2	2667673	24.3%
-	2200000	20.0%
1	634755	5.8%
8	527848	4.8%
9	355762	3.2%
7	305494	2.8%
3	213391	1.9%
6	195174	1.8%
5	140293	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8800000	80.0%
Dash Punctuation	2200000	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	3636027	41.3%
2	2667673	30.3%
1	634755	7.2%
8	527848	6.0%
9	355762	4.0%
7	305494	3.5%
3	213391	2.4%
6	195174	2.2%
5	140293	1.6%
4	123583	1.4%

Dash Punctuation

Value	Count	Frequency (%)
-	2200000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11000000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	3636027	33.1%
2	2667673	24.3%
-	2200000	20.0%
1	634755	5.8%
8	527848	4.8%
9	355762	3.2%
7	305494	2.8%
3	213391	1.9%
6	195174	1.8%
5	140293	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11000000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	3636027	33.1%
2	2667673	24.3%
-	2200000	20.0%
1	634755	5.8%
8	527848	4.8%
9	355762	3.2%
7	305494	2.8%
3	213391	1.9%
6	195174	1.8%
5	140293	1.3%

listing_color
Categorical

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

BLACK	228733
WHITE	219585
UNKNOWN	157496
SILVER	141920
GRAY	138705
Other values (10)	213561

Length

Max length	7
Median length	6
Mean length	5.028751818
Min length	3

Characters and Unicode

Total characters	5531627
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SILVER
2nd row	BLACK
3rd row	SILVER
4th row	SILVER
5th row	BLACK

Common Values

Value	Count	Frequency (%)
BLACK	228733	20.8%
WHITE	219585	20.0%
UNKNOWN	157496	14.3%
SILVER	141920	12.9%
GRAY	138705	12.6%
RED	97584	8.9%
BLUE	94344	8.6%
GREEN	7175	0.7%
BROWN	5132	0.5%
ORANGE	4416	0.4%
Other values (5)	4910	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
black	228733	20.8%
white	219585	20.0%
unknown	157496	14.3%
silver	141920	12.9%
gray	138705	12.6%
red	97584	8.9%
blue	94344	8.6%
green	7175	0.7%
brown	5132	0.5%
orange	4416	0.4%
Other values (5)	4910	0.4%

Most occurring characters

Value	Count	Frequency (%)
E	575480	10.4%
N	489241	8.8%
L	471221	8.5%
R	395301	7.1%
K	386259	7.0%
W	383557	6.9%
A	373422	6.8%
I	361535	6.5%
B	328209	5.9%
U	252209	4.6%
Other values (10)	1515193	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5531627	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	575480	10.4%
N	489241	8.8%
L	471221	8.5%
R	395301	7.1%
K	386259	7.0%
W	383557	6.9%
A	373422	6.8%
I	361535	6.5%
B	328209	5.9%
U	252209	4.6%
Other values (10)	1515193	27.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5531627	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	575480	10.4%
N	489241	8.8%
L	471221	8.5%
R	395301	7.1%
K	386259	7.0%
W	383557	6.9%
A	373422	6.8%
I	361535	6.5%
B	328209	5.9%
U	252209	4.6%
Other values (10)	1515193	27.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5531627	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	575480	10.4%
N	489241	8.8%
L	471221	8.5%
R	395301	7.1%
K	386259	7.0%
W	383557	6.9%
A	373422	6.8%
I	361535	6.5%
B	328209	5.9%
U	252209	4.6%
Other values (10)	1515193	27.4%

listing_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	1100000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	275174353.3

Minimum	67762256
Maximum	281871240
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	67762256
5-th percentile	258643465.6
Q1	274018498.5
median	278172000
Q3	280140858.8
95-th percentile	281419600.2
Maximum	281871240
Range	214108984
Interquartile range (IQR)	6122360.25

Descriptive statistics

Standard deviation	8378872.014
Coefficient of variation (CV)	0.03044932026
Kurtosis	29.13908752
Mean	275174353.3
Median Absolute Deviation (MAD)	2424139.5
Skewness	-3.598259209
Sum	3.026917887 × 10¹⁴
Variance	7.020549622 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
276675304	1	< 0.1%
277687097	1	< 0.1%
258969182	1	< 0.1%
278908946	1	< 0.1%
278609757	1	< 0.1%
281286867	1	< 0.1%
277741127	1	< 0.1%
273478763	1	< 0.1%
276176501	1	< 0.1%
261267217	1	< 0.1%
Other values (1099990)	1099990	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
67762256	1	< 0.1%
70735432	1	< 0.1%
72676056	1	< 0.1%
75257631	1	< 0.1%
83938776	1	< 0.1%
86901529	1	< 0.1%
95357213	1	< 0.1%
96305013	1	< 0.1%
98730625	1	< 0.1%
104351484	1	< 0.1%

Value	Count	Frequency (%)
281871240	1	< 0.1%
281871227	1	< 0.1%
281871225	1	< 0.1%
281870018	1	< 0.1%
281870005	1	< 0.1%
281868571	1	< 0.1%
281868569	1	< 0.1%
281868568	1	< 0.1%
281868566	1	< 0.1%
281866867	1	< 0.1%

maximum_seating
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

5 seats	742593
7 seats	125754
6 seats	119943
8 seats	87657
4 seats	22713
Other values (6)	1340

Length

Max length	8
Median length	7
Mean length	7.000467273
Min length	7

Characters and Unicode

Total characters	7700514
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5 seats
2nd row	4 seats
3rd row	8 seats
4th row	8 seats
5th row	5 seats

Common Values

Value	Count	Frequency (%)
5 seats	742593	67.5%
7 seats	125754	11.4%
6 seats	119943	10.9%
8 seats	87657	8.0%
4 seats	22713	2.1%
9 seats	640	0.1%
15 seats	453	< 0.1%
3 seats	181	< 0.1%
10 seats	35	< 0.1%
12 seats	26	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
seats	1100000	50.0%
5	742593	33.8%
7	125754	5.7%
6	119943	5.5%
8	87657	4.0%
4	22713	1.0%
9	640	< 0.1%
15	453	< 0.1%
3	181	< 0.1%
10	35	< 0.1%
Other values (2)	31	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	2200000	28.6%
	1100000	14.3%
e	1100000	14.3%
a	1100000	14.3%
t	1100000	14.3%
5	743046	9.6%
7	125754	1.6%
6	119943	1.6%
8	87657	1.1%
4	22713	0.3%
Other values (5)	1401	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5500000	71.4%
Decimal Number	1100514	14.3%
Space Separator	1100000	14.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	743046	67.5%
7	125754	11.4%
6	119943	10.9%
8	87657	8.0%
4	22713	2.1%
9	640	0.1%
1	514	< 0.1%
3	181	< 0.1%
0	35	< 0.1%
2	31	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
s	2200000	40.0%
e	1100000	20.0%
a	1100000	20.0%
t	1100000	20.0%

Space Separator

Value	Count	Frequency (%)
	1100000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5500000	71.4%
Common	2200514	28.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
	1100000	50.0%
5	743046	33.8%
7	125754	5.7%
6	119943	5.5%
8	87657	4.0%
4	22713	1.0%
9	640	< 0.1%
1	514	< 0.1%
3	181	< 0.1%
0	35	< 0.1%

Latin

Value	Count	Frequency (%)
s	2200000	40.0%
e	1100000	20.0%
a	1100000	20.0%
t	1100000	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7700514	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	2200000	28.6%
	1100000	14.3%
e	1100000	14.3%
a	1100000	14.3%
t	1100000	14.3%
5	743046	9.6%
7	125754	1.6%
6	119943	1.6%
8	87657	1.1%
4	22713	0.3%
Other values (5)	1401	< 0.1%

mileage
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	126812
Distinct (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21762.19085

Minimum	0
Maximum	1225238
Zeros	97317
Zeros (%)	8.8%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	500
Q3	33934
95-th percentile	93570.05
Maximum	1225238
Range	1225238
Interquartile range (IQR)	33929

Descriptive statistics

Standard deviation	33635.16422
Coefficient of variation (CV)	1.545578037
Kurtosis	12.5673735
Mean	21762.19085
Median Absolute Deviation (MAD)	500
Skewness	2.392922704
Sum	2.393840994 × 10¹⁰
Variance	1131324272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	97317	8.8%
10	61408	5.6%
5	59799	5.4%
3	33176	3.0%
2	31963	2.9%
1	31089	2.8%
6	25852	2.4%
11	21716	2.0%
4	21661	2.0%
12	20937	1.9%
Other values (126802)	695082	63.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	97317	8.8%
1	31089	2.8%
2	31963	2.9%
3	33176	3.0%
4	21661	2.0%
5	59799	5.4%
6	25852	2.4%
7	19106	1.7%
8	17545	1.6%
9	14771	1.3%

Value	Count	Frequency (%)
1225238	1	< 0.1%
1111111	4	< 0.1%
999999	1	< 0.1%
785778	1	< 0.1%
514033	1	< 0.1%
399496	1	< 0.1%
381553	1	< 0.1%
381519	1	< 0.1%
380584	1	< 0.1%
379647	1	< 0.1%

model_name
Categorical

HIGH CARDINALITY

Distinct	656
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

F-150	55407
1500	34728
Silverado 1500	30136
Rogue	27564
Trax	24309
Other values (651)	927856

Length

Max length	26
Median length	22
Mean length	6.696895455
Min length	2

Characters and Unicode

Total characters	7366585
Distinct characters	65
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	45 ?
Unique (%)	< 0.1%

Sample

1st row	Malibu
2nd row	RC 350
3rd row	Traverse
4th row	Traverse
5th row	Grand Cherokee

Common Values

Value	Count	Frequency (%)
F-150	55407	5.0%
1500	34728	3.2%
Silverado 1500	30136	2.7%
Rogue	27564	2.5%
Trax	24309	2.2%
CR-V	23121	2.1%
Grand Cherokee	21240	1.9%
Cherokee	19438	1.8%
Altima	18151	1.7%
Equinox	18026	1.6%
Other values (646)	827880	75.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1500	73858	5.9%
f-150	55407	4.4%
cherokee	40678	3.2%
rogue	33023	2.6%
grand	31856	2.5%
silverado	30159	2.4%
trax	24309	1.9%
cr-v	23121	1.8%
civic	19165	1.5%
altima	18215	1.5%
Other values (583)	903465	72.1%

Most occurring characters

Value	Count	Frequency (%)
a	647779	8.8%
e	594312	8.1%
r	548269	7.4%
o	458878	6.2%
n	350955	4.8%
i	345087	4.7%
l	253294	3.4%
0	244423	3.3%
t	244302	3.3%
C	228167	3.1%
Other values (55)	3451119	46.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5006523	68.0%
Uppercase Letter	1455651	19.8%
Decimal Number	623598	8.5%
Space Separator	153256	2.1%
Dash Punctuation	125907	1.7%
Other Punctuation	1650	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	647779	12.9%
e	594312	11.9%
r	548269	11.0%
o	458878	9.2%
n	350955	7.0%
i	345087	6.9%
l	253294	5.1%
t	244302	4.9%
s	222790	4.4%
u	198698	4.0%
Other values (16)	1142159	22.8%

Uppercase Letter

Value	Count	Frequency (%)
C	228167	15.7%
S	155928	10.7%
E	133861	9.2%
T	119260	8.2%
R	110270	7.6%
F	105510	7.2%
X	88146	6.1%
A	85044	5.8%
G	65199	4.5%
M	56785	3.9%
Other values (16)	307481	21.1%

Decimal Number

Value	Count	Frequency (%)
0	244423	39.2%
5	168908	27.1%
1	130634	20.9%
3	23742	3.8%
4	21206	3.4%
6	18140	2.9%
9	5531	0.9%
7	3991	0.6%
8	3567	0.6%
2	3456	0.6%

Space Separator

Value	Count	Frequency (%)
	153256	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	125907	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	1650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6462174	87.7%
Common	904411	12.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	647779	10.0%
e	594312	9.2%
r	548269	8.5%
o	458878	7.1%
n	350955	5.4%
i	345087	5.3%
l	253294	3.9%
t	244302	3.8%
C	228167	3.5%
s	222790	3.4%
Other values (42)	2568341	39.7%

Common

Value	Count	Frequency (%)
0	244423	27.0%
5	168908	18.7%
	153256	16.9%
1	130634	14.4%
-	125907	13.9%
3	23742	2.6%
4	21206	2.3%
6	18140	2.0%
9	5531	0.6%
7	3991	0.4%
Other values (3)	8673	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7366585	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	647779	8.8%
e	594312	8.1%
r	548269	7.4%
o	458878	6.2%
n	350955	4.8%
i	345087	4.7%
l	253294	3.4%
0	244423	3.3%
t	244302	3.3%
C	228167	3.1%
Other values (55)	3451119	46.8%

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	68803
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30329.5275

Minimum	484
Maximum	2698500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	484
5-th percentile	12299
Q1	19988
median	27068
Q3	38335
95-th percentile	56554
Maximum	2698500
Range	2698016
Interquartile range (IQR)	18347

Descriptive statistics

Standard deviation	15307.59773
Coefficient of variation (CV)	0.5047094035
Kurtosis	1232.734446
Mean	30329.5275
Median Absolute Deviation (MAD)	8452
Skewness	9.621228551
Sum	3.336248025 × 10¹⁰
Variance	234322548.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17995	2012	0.2%
18995	1969	0.2%
19995	1960	0.2%
16995	1947	0.2%
15995	1621	0.1%
14995	1516	0.1%
17500	1513	0.1%
20995	1487	0.1%
21995	1445	0.1%
16500	1442	0.1%
Other values (68793)	1083088	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
484	3	< 0.1%
498	1	< 0.1%
500	1	< 0.1%
650	1	< 0.1%
749	1	< 0.1%
750	1	< 0.1%
762	1	< 0.1%
777	1	< 0.1%
795	1	< 0.1%
800	2	< 0.1%

Value	Count	Frequency (%)
2698500	1	< 0.1%
2175000	1	< 0.1%
999995	1	< 0.1%
988512	1	< 0.1%
579525	1	< 0.1%
544500	1	< 0.1%
449995	1	< 0.1%
418500	1	< 0.1%
414991	1	< 0.1%
405675	1	< 0.1%

transmission
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

A	885828
CVT	197889
M	13307
Dual Clutch	2976

Length

Max length	11
Median length	1
Mean length	1.386852727
Min length	1

Characters and Unicode

Total characters	1525538
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	885828	80.5%
CVT	197889	18.0%
M	13307	1.2%
Dual Clutch	2976	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
a	885828	80.3%
cvt	197889	17.9%
m	13307	1.2%
dual	2976	0.3%
clutch	2976	0.3%

Most occurring characters

Value	Count	Frequency (%)
A	885828	58.1%
C	200865	13.2%
V	197889	13.0%
T	197889	13.0%
M	13307	0.9%
u	5952	0.4%
l	5952	0.4%
D	2976	0.2%
a	2976	0.2%
	2976	0.2%
Other values (3)	8928	0.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1498754	98.2%
Lowercase Letter	23808	1.6%
Space Separator	2976	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	885828	59.1%
C	200865	13.4%
V	197889	13.2%
T	197889	13.2%
M	13307	0.9%
D	2976	0.2%

Lowercase Letter

Value	Count	Frequency (%)
u	5952	25.0%
l	5952	25.0%
a	2976	12.5%
t	2976	12.5%
c	2976	12.5%
h	2976	12.5%

Space Separator

Value	Count	Frequency (%)
	2976	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1522562	99.8%
Common	2976	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	885828	58.2%
C	200865	13.2%
V	197889	13.0%
T	197889	13.0%
M	13307	0.9%
u	5952	0.4%
l	5952	0.4%
D	2976	0.2%
a	2976	0.2%
t	2976	0.2%
Other values (2)	5952	0.4%

Common

Value	Count	Frequency (%)
	2976	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1525538	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	885828	58.1%
C	200865	13.2%
V	197889	13.0%
T	197889	13.0%
M	13307	0.9%
u	5952	0.4%
l	5952	0.4%
D	2976	0.2%
a	2976	0.2%
	2976	0.2%
Other values (3)	8928	0.6%

transmission_display
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Automatic	468215
Continuously Variable Transmission	197207
6-Speed Automatic	170695
8-Speed Automatic	132227
9-Speed Automatic	77976
Other values (25)	53680

Length

Max length	34
Median length	27
Mean length	16.67471091
Min length	6

Characters and Unicode

Total characters	18342182
Distinct characters	37
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	6-Speed Automatic
2nd row	6-Speed Automatic
3rd row	9-Speed Automatic
4th row	6-Speed Automatic
5th row	8-Speed Automatic

Common Values

Value	Count	Frequency (%)
Automatic	468215	42.6%
Continuously Variable Transmission	197207	17.9%
6-Speed Automatic	170695	15.5%
8-Speed Automatic	132227	12.0%
9-Speed Automatic	77976	7.1%
6-Speed Automatic Overdrive	11256	1.0%
5-Speed Automatic	9500	0.9%
4-Speed Automatic	7821	0.7%
7-Speed Automatic	7686	0.7%
6-Speed Manual	6830	0.6%
Other values (20)	10587	1.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
automatic	885828	45.7%
variable	197207	10.2%
transmission	197207	10.2%
continuously	197207	10.2%
6-speed	190088	9.8%
8-speed	133448	6.9%
9-speed	77985	4.0%
manual	13307	0.7%
overdrive	11456	0.6%
5-speed	10947	0.6%
Other values (8)	23573	1.2%

Most occurring characters

Value	Count	Frequency (%)
t	1971839	10.8%
i	1686112	9.2%
a	1507039	8.2%
o	1477449	8.1%
u	1299501	7.1%
m	1083035	5.9%
e	1078933	5.9%
c	888804	4.8%
A	885828	4.8%
	838253	4.6%
Other values (27)	5625389	30.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14705246	80.2%
Uppercase Letter	1939617	10.6%
Space Separator	838253	4.6%
Decimal Number	429659	2.3%
Dash Punctuation	429407	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1971839	13.4%
i	1686112	11.5%
a	1507039	10.2%
o	1477449	10.0%
u	1299501	8.8%
m	1083035	7.4%
e	1078933	7.3%
c	888804	6.0%
n	802135	5.5%
s	788828	5.4%
Other values (8)	2121571	14.4%

Decimal Number

Value	Count	Frequency (%)
6	190088	44.2%
8	133448	31.1%
9	77985	18.2%
5	10947	2.5%
7	8835	2.1%
4	7843	1.8%
1	254	0.1%
0	252	0.1%
3	7	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	885828	45.7%
S	429407	22.1%
C	200865	10.4%
T	197889	10.2%
V	197889	10.2%
M	13307	0.7%
O	11456	0.6%
D	2976	0.2%

Space Separator

Value	Count	Frequency (%)
	838253	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	429407	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16644863	90.7%
Common	1697319	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1971839	11.8%
i	1686112	10.1%
a	1507039	9.1%
o	1477449	8.9%
u	1299501	7.8%
m	1083035	6.5%
e	1078933	6.5%
c	888804	5.3%
A	885828	5.3%
n	802135	4.8%
Other values (16)	3964188	23.8%

Common

Value	Count	Frequency (%)
	838253	49.4%
-	429407	25.3%
6	190088	11.2%
8	133448	7.9%
9	77985	4.6%
5	10947	0.6%
7	8835	0.5%
4	7843	0.5%
1	254	< 0.1%
0	252	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18342182	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1971839	10.8%
i	1686112	9.2%
a	1507039	8.2%
o	1477449	8.1%
u	1299501	7.1%
m	1083035	5.9%
e	1078933	5.9%
c	888804	4.8%
A	885828	4.8%
	838253	4.6%
Other values (27)	5625389	30.7%

wheel_system
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

FWD	468267
AWD	298310
4WD	247006
RWD	47690
4X2	38727

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	3300000
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FWD
2nd row	AWD
3rd row	FWD
4th row	AWD
5th row	4WD

Common Values

Value	Count	Frequency (%)
FWD	468267	42.6%
AWD	298310	27.1%
4WD	247006	22.5%
RWD	47690	4.3%
4X2	38727	3.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
fwd	468267	42.6%
awd	298310	27.1%
4wd	247006	22.5%
rwd	47690	4.3%
4x2	38727	3.5%

Most occurring characters

Value	Count	Frequency (%)
W	1061273	32.2%
D	1061273	32.2%
F	468267	14.2%
A	298310	9.0%
4	285733	8.7%
R	47690	1.4%
X	38727	1.2%
2	38727	1.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2975540	90.2%
Decimal Number	324460	9.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
W	1061273	35.7%
D	1061273	35.7%
F	468267	15.7%
A	298310	10.0%
R	47690	1.6%
X	38727	1.3%

Decimal Number

Value	Count	Frequency (%)
4	285733	88.1%
2	38727	11.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2975540	90.2%
Common	324460	9.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	1061273	35.7%
D	1061273	35.7%
F	468267	15.7%
A	298310	10.0%
R	47690	1.6%
X	38727	1.3%

Common

Value	Count	Frequency (%)
4	285733	88.1%
2	38727	11.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3300000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	1061273	32.2%
D	1061273	32.2%
F	468267	14.2%
A	298310	9.0%
4	285733	8.7%
R	47690	1.4%
X	38727	1.2%
2	38727	1.2%

wheelbase
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	309
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.6296169

Minimum	90.6
Maximum	164.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	90.6
5-th percentile	100.6
Q1	106.3
median	111.2
Q3	118.1
95-th percentile	145
Maximum	164.6
Range	74
Interquartile range (IQR)	11.8

Descriptive statistics

Standard deviation	13.18463103
Coefficient of variation (CV)	0.1150194111
Kurtosis	1.043107448
Mean	114.6296169
Median Absolute Deviation (MAD)	5.3
Skewness	1.427942261
Sum	126092578.6
Variance	173.8344954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
106.3	57199	5.2%
112.2	52038	4.7%
145	50324	4.6%
105.1	34137	3.1%
106.5	31198	2.8%
100.6	30649	2.8%
111.2	28207	2.6%
111.4	27371	2.5%
104.7	25454	2.3%
111	23969	2.2%
Other values (299)	739454	67.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
90.6	238	< 0.1%
93.3	6	< 0.1%
93.4	72	< 0.1%
93.5	179	< 0.1%
94.9	5	< 0.1%
95.4	977	0.1%
95.6	3	< 0.1%
96.1	3	< 0.1%
96.5	1128	0.1%
96.8	953	0.1%

Value	Count	Frequency (%)
164.6	60	< 0.1%
163.7	21	< 0.1%
163.1	6	< 0.1%
163	3	< 0.1%
160.3	7	< 0.1%
157.5	19	< 0.1%
157.1	3	< 0.1%
157	37	< 0.1%
156.8	2863	0.3%
156.6	6	< 0.1%

width
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	231
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.37142236

Minimum	62.9
Maximum	98.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	62.9
5-th percentile	69.9
Q1	72.6
median	77.3
Q3	82.6
95-th percentile	96.8
Maximum	98.6
Range	35.7
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.249061963
Coefficient of variation (CV)	0.09249624091
Kurtosis	0.1253460526
Mean	78.37142236
Median Absolute Deviation (MAD)	4.8
Skewness	0.8400589133
Sum	86208564.6
Variance	52.54889934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
96.8	53208	4.8%
72.4	47151	4.3%
73	42242	3.8%
69.9	34062	3.1%
70.9	32527	3.0%
73.2	28975	2.6%
81.2	26976	2.5%
80	26427	2.4%
82.1	24948	2.3%
70.8	24604	2.2%
Other values (221)	758880	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
62.9	179	< 0.1%
63.7	1	< 0.1%
64.1	32	< 0.1%
65.4	5	< 0.1%
65.6	1108	0.1%
65.7	888	0.1%
65.9	2	< 0.1%
66.1	18	< 0.1%
66.2	20	< 0.1%
66.3	10	< 0.1%

Value	Count	Frequency (%)
98.6	41	< 0.1%
97.4	441	< 0.1%
97	2004	0.2%
96.8	53208	4.8%
95.7	17	< 0.1%
93.8	822	0.1%
93.4	9338	0.8%
92.3	5625	0.5%
91.8	1732	0.2%
91.5	1668	0.2%

year
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.496676

Minimum	1989
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	1989
5-th percentile	2014
Q1	2017
median	2020
Q3	2020
95-th percentile	2020
Maximum	2021
Range	32
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.427173766
Coefficient of variation (CV)	0.00120246607
Kurtosis	7.782431978
Mean	2018.496676
Median Absolute Deviation (MAD)	0
Skewness	-2.321185733
Sum	2220346344
Variance	5.891172491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
2020	551435	50.1%
2017	154762	14.1%
2019	117682	10.7%
2018	88384	8.0%
2016	43572	4.0%
2021	40716	3.7%
2015	30126	2.7%
2014	21135	1.9%
2013	15915	1.4%
2012	10763	1.0%
Other values (22)	25510	2.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1989	1	< 0.1%
1991	2	< 0.1%
1992	5	< 0.1%
1993	4	< 0.1%
1994	7	< 0.1%
1995	18	< 0.1%
1996	8	< 0.1%
1997	33	< 0.1%
1998	53	< 0.1%
1999	55	< 0.1%

Value	Count	Frequency (%)
2021	40716	3.7%
2020	551435	50.1%
2019	117682	10.7%
2018	88384	8.0%
2017	154762	14.1%
2016	43572	4.0%
2015	30126	2.7%
2014	21135	1.9%
2013	15915	1.4%
2012	10763	1.0%

Torque_lb_ft
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	341
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.8175509

Minimum	74
Maximum	808
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	74
5-th percentile	138
Q1	176
median	250
Q3	305
95-th percentile	395
Maximum	808
Range	734
Interquartile range (IQR)	129

Descriptive statistics

Standard deviation	87.41140026
Coefficient of variation (CV)	0.3499009575
Kurtosis	-0.06472948451
Mean	249.8175509
Median Absolute Deviation (MAD)	69
Skewness	0.5414514795
Sum	274799306
Variance	7640.752895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
395	76196	6.9%
170	46707	4.2%
310	36767	3.3%
355	36451	3.3%
138	33069	3.0%
147	31199	2.8%
295	30043	2.7%
181	29578	2.7%
280	26063	2.4%
185	24705	2.2%
Other values (331)	729222	66.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
74	49	< 0.1%
78	1939	0.2%
84	179	< 0.1%
90	1	< 0.1%
93	4	< 0.1%
96	1	< 0.1%
100	45	< 0.1%
101	167	< 0.1%
103	12	< 0.1%
104	4	< 0.1%

Value	Count	Frequency (%)
808	13	< 0.1%
797	125	< 0.1%
760	37	< 0.1%
717	127	< 0.1%
707	396	< 0.1%
700	4	< 0.1%
662	15	< 0.1%
650	135	< 0.1%
640	16	< 0.1%
633	2	< 0.1%

Torque_RPM
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	89
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3539.321395

Minimum	200
Maximum	6800
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.4 MiB

Quantile statistics

Minimum	200
5-th percentile	1400
Q1	2500
median	4000
Q3	4400
95-th percentile	4900
Maximum	6800
Range	6600
Interquartile range (IQR)	1900

Descriptive statistics

Standard deviation	1251.836388
Coefficient of variation (CV)	0.3536939001
Kurtosis	-0.2316823695
Mean	3539.321395
Median Absolute Deviation (MAD)	500
Skewness	-0.9396727868
Sum	3893253534
Variance	1567094.341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4000	125618	11.4%
4400	118985	10.8%
4500	76954	7.0%
4100	59262	5.4%
4700	56916	5.2%
2000	55620	5.1%
1500	51633	4.7%
4800	47386	4.3%
3000	44119	4.0%
3950	33724	3.1%
Other values (79)	429783	39.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200	30649	2.8%
233	91	< 0.1%
323	27	< 0.1%
400	11	< 0.1%
1000	11	< 0.1%
1200	2809	0.3%
1250	4050	0.4%
1300	5523	0.5%
1350	1238	0.1%
1370	1764	0.2%

Value	Count	Frequency (%)
6800	3	< 0.1%
6600	35	< 0.1%
6400	171	< 0.1%
6100	22	< 0.1%
6000	6	< 0.1%
5800	2	< 0.1%
5700	1966	0.2%
5600	88	< 0.1%
5500	21	< 0.1%
5400	45	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	back_legroom	body_type	city_fuel_economy	daysonmarket	engine_cylinders	engine_displacement	franchise_make	front_legroom	fuel_tank_volume	fuel_type	height	highway_fuel_economy	horsepower	is_new	length	listed_date	listing_color	listing_id	maximum_seating	mileage	model_name	price	transmission	transmission_display	wheel_system	wheelbase	width	year	Torque_lb_ft	Torque_RPM
0	38.1	Sedan	27.0	55	I4	1500.0	Chevrolet	42.0	15.8 gal	Gasoline	57.6	36.0	160.0	False	193.8	2020-07-16	SILVER	276675304	5 seats	42394.0	Malibu	14639.0	A	6-Speed Automatic	FWD	111.4	73.0	2018	160	2500
1	27.3	Coupe	18.0	36	V6	3500.0	Jeep	45.4	17.4 gal	Gasoline	55.1	24.0	311.0	False	184.8	2020-08-04	BLACK	278352194	4 seats	62251.0	RC 350	32000.0	A	6-Speed Automatic	AWD	107.5	81.5	2018	311	4800
2	38.4	SUV / Crossover	18.0	27	V6	3600.0	Chevrolet	41.0	19.4 gal	Gasoline	70.7	27.0	310.0	False	204.3	2020-08-13	SILVER	279129180	8 seats	36410.0	Traverse	23723.0	A	9-Speed Automatic	FWD	120.9	78.6	2018	310	2800
3	36.8	SUV / Crossover	15.0	27	V6	3600.0	Chevrolet	41.3	22 gal	Gasoline	69.9	22.0	281.0	False	203.7	2020-08-13	SILVER	279129181	8 seats	36055.0	Traverse	22422.0	A	6-Speed Automatic	AWD	118.9	78.5	2017	281	3400
4	38.6	SUV / Crossover	18.0	24	V6	3600.0	Chevrolet	40.3	24.6 gal	Gasoline	69.3	25.0	295.0	False	189.8	2020-08-16	BLACK	279531621	5 seats	25745.0	Grand Cherokee	29424.0	A	8-Speed Automatic	4WD	114.8	84.8	2018	295	4800
5	39.4	SUV / Crossover	20.0	20	I4	2400.0	Jeep	40.6	13.5 gal	Gasoline	65.0	25.0	172.0	False	175.1	2020-08-20	BLACK	279775073	5 seats	14607.0	Compass	17000.0	A	6-Speed Automatic	4WD	103.7	71.4	2017	172	4400
6	34.1	Coupe	27.0	102	I4	2000.0	Jeep	42.6	13.2 gal	Gasoline	55.1	34.0	147.0	False	166.9	2020-05-30	RED	272950938	4 seats	3073.0	Veloster	16900.0	A	6-Speed Automatic	FWD	104.3	70.9	2020	147	4500
7	38.6	SUV / Crossover	18.0	35	V6	3000.0	Jeep	40.3	24.6 gal	Gasoline	69.3	25.0	241.0	False	189.8	2020-08-05	SILVER	278462572	5 seats	16467.0	Grand Cherokee	25500.0	A	8-Speed Automatic	4WD	114.8	84.8	2017	360	4250
8	38.4	SUV / Crossover	18.0	41	V6	3600.0	Chevrolet	41.0	19.4 gal	Gasoline	70.7	27.0	310.0	False	204.3	2020-07-30	WHITE	277998707	8 seats	37536.0	Traverse	23939.0	A	9-Speed Automatic	FWD	120.9	78.6	2018	310	2800
9	39.5	SUV / Crossover	24.0	246	I4	2000.0	Cadillac	40.4	15.9 gal	Gasoline	64.1	30.0	237.0	False	181.1	2020-01-07	BLACK	262490501	5 seats	6946.0	XT4	31339.0	A	9-Speed Automatic	FWD	109.4	83.5	2019	237	1500

Last rows

	back_legroom	body_type	city_fuel_economy	daysonmarket	engine_cylinders	engine_displacement	franchise_make	front_legroom	fuel_tank_volume	fuel_type	height	highway_fuel_economy	horsepower	is_new	length	listed_date	listing_color	listing_id	maximum_seating	mileage	model_name	price	transmission	transmission_display	wheel_system	wheelbase	width	year	Torque_lb_ft	Torque_RPM
1099990	39.4	SUV / Crossover	18.0	10	V6	3300.0	Buick	44.1	18.8 gal	Gasoline	66.5	25.0	290.0	False	187.4	2020-09-01	BLACK	280885792	7 seats	32652.0	Sorento	29900.0	A	Automatic	FWD	109.4	74.4	2018	290	5300
1099991	35.7	SUV / Crossover	26.0	342	I4	1400.0	Chevrolet	40.8	14 gal	Gasoline	66.0	31.0	138.0	True	167.6	2019-10-05	WHITE	254356206	5 seats	4043.0	Trax	19087.0	A	6-Speed Automatic	FWD	100.6	69.9	2020	138	200
1099992	35.8	Pickup Truck	18.0	31	V6	3600.0	Chevrolet	45.0	21 gal	Gasoline	70.7	25.0	308.0	True	212.7	2020-08-11	WHITE	278965192	5 seats	3.0	Colorado	29268.0	A	8-Speed Automatic	4X2	128.3	83.9	2021	308	4000
1099993	38.1	Sedan	27.0	499	I4	1500.0	Chevrolet	42.0	15.8 gal	Gasoline	57.6	36.0	160.0	False	193.8	2019-05-01	RED	239502065	5 seats	4165.0	Malibu	18465.0	A	6-Speed Automatic	FWD	111.4	73.0	2018	160	2500
1099994	35.7	SUV / Crossover	26.0	339	I4	1400.0	Chevrolet	40.8	14 gal	Gasoline	66.0	31.0	138.0	True	167.6	2019-10-08	UNKNOWN	254539054	5 seats	7.0	Trax	19087.0	A	6-Speed Automatic	FWD	100.6	69.9	2020	138	200
1099995	43.6	Pickup Truck	15.0	13	V8 Flex Fuel Vehicle	5000.0	Ford	43.9	26 gal	Flex Fuel Vehicle	77.2	21.0	395.0	True	231.9	2020-08-29	WHITE	280732107	5 seats	3.0	F-150	61577.0	A	Automatic	4WD	145.0	96.8	2020	375	3500
1099996	45.2	Pickup Truck	15.0	1	V8	5700.0	RAM	40.9	26 gal	Gasoline	77.5	22.0	395.0	True	232.9	2020-09-10	BLUE	281771612	6 seats	20.0	1500	41595.0	A	Automatic	4X2	144.6	82.1	2020	395	3950
1099997	38.6	SUV / Crossover	14.0	14	V8	5700.0	Dodge	40.3	24.6 gal	Gasoline	71.9	22.0	360.0	True	201.2	2020-08-28	GRAY	280578742	7 seats	22.0	Durango	44991.0	A	Automatic	RWD	119.8	85.5	2020	360	4250
1099998	38.1	Sedan	25.0	30	I4	1800.0	Volkswagen	41.2	14.5 gal	Gasoline	57.2	35.0	170.0	False	183.3	2020-08-12	RED	279061599	5 seats	31490.0	Jetta	16969.0	A	6-Speed Automatic	FWD	104.4	70.0	2017	170	1500
1099999	30.3	Coupe	17.0	45	V6	3800.0	Chevrolet	44.1	17.2 gal	Gasoline	54.5	24.0	348.0	False	182.3	2020-07-28	SILVER	277726752	4 seats	39076.0	Genesis Coupe	17992.0	M	6-Speed Manual	RWD	111.0	73.4	2016	348	5100

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common